The NOT operator is used most often in the phone and ZIP code fields. Using the NOT search will provide a list of everybody who meets the search criterion, except those you have indicated that you do not want to find. You can specify a NOT search by using the word ".not." You may also use an exclamation point ( ! ).
For example, you would like to retrieve all listings in California, but not those in the 707 and 916 area codes. In the state field enter CA, and in the phone field you would type:
.NOT. 707 .NOT. 916
Your display will then show all the listings in California except not those in the 707 or the 916 area codes.